// 封装数据库查询语句
var flow_sql = {
    insertOne: 'INSERT INTO article.flow(click_num, forward, essay_id) VALUES(?,?,?);',
    deleteOne: 'DELETE FROM article.flow WHERE id=?;',
    updateOne: 'UPDATE flow f SET click_num=?, forward=?, essay_id=? WHERE id=?',
    selectOneOrigin: 'select * FROM flow f where f.id = ?',
    selectOne: 'select f.id, click_num, forward, e.title from flow f left join essay e on e.id = f.essay_id where f.id = ?;',
    selectAll: 'select f.id, click_num, forward, e.title from flow f left join essay e on e.id = f.essay_id;',
}
module.exports = flow_sql